Example 10-1
----------------------------------------------------------------------------------------------------------------------------------------
CREATE TABLE tblInvoices (
[InvoiceNo] varchar (10) NOT NULL, 
[InvoiceDate] smalldatetime NULL, 
[CustomerID] int NULL, 
[Description] nvarchar (100) NULL, 
[SalesID] varchar (10) NOT NULL)

Example 10-2
----------------------------------------------------------------------------------------------------------------------------------------
Function Main()
	DTSDestination("InvoiceNo") = DTSSource("InvoiceNo")
	DTSDestination("InvoiceDate") = DTSSource("InvoiceDate")
	DTSDestination("CustomerID") = DTSSource("CustomerID")
	DTSDestination("Description") = DTSSource("Description")
	DTSDestination("SalesID") = DTSSource("SalesID")
	Main = DTSTransformStat_OK
End Function

Example 10-3
----------------------------------------------------------------------------------------------------------------------------------------
CREATE TABLE [mydatabase].[dbo].[Customers] (
[CustomerID] nchar (5) NOT NULL, 
[CompanyName] nvarchar (40) NOT NULL, 
[ContactName] nvarchar (30) NULL, 
[ContactTitle] nvarchar (30) NULL, 
[Address] nvarchar (60) NULL, 
[City] nvarchar (15) NULL, 
[Region] nvarchar (15) NULL, 
[PostalCode] nvarchar (10) NULL, 
[Country] nvarchar (15) NULL, 
[Phone] nvarchar (24) NULL, 
[Fax] nvarchar (24) NULL
)


CustomerID 	CompanyName                              	Country         
-----------------	-----------------------------------------------------	--------------- 
GREAL     	Great Lakes Food Market                	USA
HUNGC      	Hungry Coyote Import Store            	USA
LAZYK      	Lazy K Kountry Store                     	USA
LETSS      	Let's Stop N Shop                        	USA
LONEP      	Lonesome Pine Restaurant              	USA
OLDWO      	Old World Delicatessen                 	USA
RATTC      	Rattlesnake Canyon Grocery            	USA
SAVEA      	Save-a-lot Markets                       	USA
SPLIR      	Split Rail Beer & Ale                    	USA
THEBI      	The Big Cheese                           	USA
THECR      	The Cracker Box                          	USA
TRAIH      	Trail's Head Gourmet Provisioners      	USA
WHITC      	White Clover Markets                     	USA


Example 10-4
----------------------------------------------------------------------------------------------------------------------------------------
Select CustomerName As Name, Address, Tel, Email
From tblCustomers
Where Activate=1


